# Usage example

The following SQL statement returns a range of changes that starts after the last handled event (of change sequence "20120723144522110000000000000901203") and until the event committed on 23-Jul-2012 at 23:00:00.00. For update we also get the before image value (here for the salary before and after).

`SELECT CHANGE.[header__change_seq],` `CHANGE.[header__stream_position],` `CHANGE.[header__operation],` `CHANGE.[header__transaction_id],` `CHANGE.[header__timestamp],` `CHANGE.[EMPLOYEE_ID],` `CHANGE.[FIRST_NAME],` `CHANGE.[LAST_NAME],` `CHANGE.[SALARY],` `BI.[SALARY],` `FROM [Replication].[HR].[EMPLOYEES_ct] CHANGE LEFT OUTER JOIN` `[Replication].[HR].[EMPLOYEES_ct] BI  ON` `BI.[header__change_seq] = CHANGE.[header$__change_seq] AND` `             BI.[header__change_oper] = 'B' ` `WHERE CHANGE.header__oper <> 'B' AND` `            CHANGE.[header__stream_position] > '20120723144522110000000000000901203' AND ` `            CHANGE.[header__stream_position] <= '2012072323000000Z' AND ` `ORDER BY` `            CHANGE.[header__stream_position] `